UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NRvSWdmy5CcMDalZiZGxApHJxaQDY8pvHz6Ja/R0nk='
WHERE
key_id = 'b255c2bc87d78b40002c5d1abdccd9659c0ca3bac971ddd6d6b7f21477587836'
AND (
token = '7NRvSWdmy5CcMDalZiZGxApHJxaQDY8pvHz6Ja/R0nk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)