UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R2Oktxqgqfpu1K6GYgAViIIIkCZi5mncNb4v3mUdToE='
WHERE
key_id = '9bf0972ad1650892e4f2b1235ff7a3cec5c43ee794915d05a12ae28b00392388'
AND (
token = 'R2Oktxqgqfpu1K6GYgAViIIIkCZi5mncNb4v3mUdToE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)