UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zO0F6sg3FLycTVo1KdI/1DAnMtS3Udn9gY5Tf6+Ccoc='
WHERE
key_id = '3380e57f3e549ecb867c86f305ffa676d8641c098ef77658b0dc37c1ea7a68b3'
AND (
token = 'zO0F6sg3FLycTVo1KdI/1DAnMtS3Udn9gY5Tf6+Ccoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)