UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+LOkaQl3O3aSd+P3n7XQdHX1iXu3XRD03zcbNwldlv8='
WHERE
key_id = 'e5e1b6e6e56f5386b085ff08ae89a5897259ab5b219737dcc3fba86b0bee527c'
AND (
token = '+LOkaQl3O3aSd+P3n7XQdHX1iXu3XRD03zcbNwldlv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)