UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZT47Yw/COB1iVuOkNADhgvbCrsUQHzp1dLUZTkAQGwg='
WHERE
key_id = '6921d6d9c02c860de82c6e5fc1c5b17dff49f3302820f524ff30ecf0001f3dac'
AND (
token = 'ZT47Yw/COB1iVuOkNADhgvbCrsUQHzp1dLUZTkAQGwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)