UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hs3VLvj3USGZVEixKK5rMARJRi8SHG8mBJpF+bWdBds='
WHERE
key_id = 'a164019da042d5054937d1e3380540e5bee839a4af0f49ee1759d37bc05b1065'
AND (
token = 'hs3VLvj3USGZVEixKK5rMARJRi8SHG8mBJpF+bWdBds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)