UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UjUwXGiA4D4KDlUTwq2Cplx54P1L75uNPHfX1RTooS8='
WHERE
key_id = 'd874a9975f6f4233579c7a1636e1342e873cd3b3fcced5db805a450fe0b0576a'
AND (
token = 'UjUwXGiA4D4KDlUTwq2Cplx54P1L75uNPHfX1RTooS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)