UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vdjL8vJ2PNbRaF8iqQi1YEq3jAA7W/m+qikN2cx+ZbY='
WHERE
key_id = 'f6dfb43cb6f3cf349400f3851b1a78f51cbc563f562700de64a4c4b50b0ac783'
AND (
token = 'vdjL8vJ2PNbRaF8iqQi1YEq3jAA7W/m+qikN2cx+ZbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)