UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e51oi3Ao5SLA+LeKloWmeLfWBt2Uj71bvCwDCM3sKzw='
WHERE
key_id = 'a6ee03f3f8f05975e045f481d440c848a5d29e4e5cc9c70a21d85fc85009f5ce'
AND (
token = 'e51oi3Ao5SLA+LeKloWmeLfWBt2Uj71bvCwDCM3sKzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)