UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hbUB0tt1HdREkrJRzmTOnh/HxYhhHs6CfiOyB8nVTUY='
WHERE
key_id = '81307b5cb572aa48765280103c2e3e00a47265914fb4571fb0186e329cd4614f'
AND (
token = 'hbUB0tt1HdREkrJRzmTOnh/HxYhhHs6CfiOyB8nVTUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)