UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sHRzCyxoZ3RamVc6k7f6a8OqaWD/R9OhR63Rhgb4EUU='
WHERE
key_id = '30d49ddd15b17d6722c48acc20fabddf3ce0c4638dfb2e040e78e8828807cb63'
AND (
token = 'sHRzCyxoZ3RamVc6k7f6a8OqaWD/R9OhR63Rhgb4EUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)