UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OyxfLVqMfE9BvaiaYeGqlxfGzf+6phvy5in9nU3xJ6s='
WHERE
key_id = 'b0da4803b508bc98e9f9034e7eacf0b8a37e908d224547756afbace33d4b5492'
AND (
token = 'OyxfLVqMfE9BvaiaYeGqlxfGzf+6phvy5in9nU3xJ6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)