UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dh1GQ/z4gAqEIKmz8A8S2y63FEn5JNxTq4Do4E46BDg='
WHERE
key_id = '5e29c6783734a16b835ab667659a61f216245a1c3be38afa73b7fb155c769fec'
AND (
token = 'dh1GQ/z4gAqEIKmz8A8S2y63FEn5JNxTq4Do4E46BDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)