UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zP51jTnhq2ltE1Q8u9X82erh6smiPi4yhNM6E/wpJzA='
WHERE
key_id = '3ebb29ca8a4fe4840dc93035824bafada27df5d4b84137094db0b5854f896a15'
AND (
token = 'zP51jTnhq2ltE1Q8u9X82erh6smiPi4yhNM6E/wpJzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)