UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4gu1xJ7KwdxaD4ojMiGuxNrTQbINJb30qtHAJzb/B0='
WHERE
key_id = 'b47f5d226cb923c470e5adad760f6fd624d5e1c48bd7ef5e3190a3b1057ea420'
AND (
token = 'a4gu1xJ7KwdxaD4ojMiGuxNrTQbINJb30qtHAJzb/B0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)