UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z5m9qDhG8+8jSXdDiJSgZiuNgmHr5WFK391Z+vfI4II='
WHERE
key_id = 'b81ac02009399105cdf1de69a51738259ab5bb341bdf51c56e4d52f9a8bea6d5'
AND (
token = 'z5m9qDhG8+8jSXdDiJSgZiuNgmHr5WFK391Z+vfI4II='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)